﻿CREATE VIEW [dbo].[JF_V_ModelRelationDetail]
	AS 
	SELECT MR.*,
		M1.Code as Model1Code,
		M1.Name as Model1Name,
		M2.Code as Model2Code,
		M2.Name as Model2Name
	FROM JF_T_ModelRelation as MR
		inner join JF_T_Model as M1 on M1.Id = MR.Model1Id
		inner join JF_T_Model as M2 on M2.Id = MR.Model2Id
